<?php

/**
 * Zmienne odwzorywujące schemat bazy danych
 * @author Anna Rybka
 *
 */
class BoaConstans {
	
	const USER_TABLE = "users";
	const USER_COLUMN_ID = "id";
	const USER_COLUMN_LOGIN = "login";
	const USER_COLUMN_PASSWORD = "password";
	const USER_COLUMN_ROLE_ID = "rid";
	const USER_COLUMN_NAME = "name";
	const USER_COLUMN_SURNAME = "surname";
	const USER_COLUMN_ADDRESS = "address";
	const USER_COLUMN_PHONE = "phone";
	const USER_COLUMN_CITY = "city";
	
	const SERVICE_TABLE = "service";
	const SERVICE_COLUMN_ID = "id";
	const SERVICE_COLUMN_NAME = "name";
	const SERVICE_COLUMN_DESCR = "descr";
	const SERVICE_COLUMN_PERIOD = "period";
	const SERVICE_COLUMN_ACTIVE = "active";
	const SERVICE_COLUMN_PRICE = "price";
	
	const SERVICE_PART_TABLE = "servicepart";
	const SERVICE_PART_COLUMN_ID = "id";
	const SERVICE_PART_COLUMN_NAME = "name";
	const SERVICE_PART_COLUMN_TYPE = "type";
	
	const SERVICE_SERVICE_PART_TABLE = "serviceservicepart";
	const SERVICE_SERVICE_PART_COLUMN_SID = "sid";
	const SERVICE_SERVICE_PART_COLUMN_SPID = "spid";
	
	const PROMOTION_TABLE = "promotion";
	const PROMOTION_COLUMN_ID = "id";
	const PROMOTION_COLUMN_DATE_FROM = "date_from";
	const PROMOTION_COLUMN_DATE_TO = "date_to";
	const PROMOTION_COLUMN_NAME = "name";
	const PROMOTION_COLUMN_VALUE = "value";
	const PROMOTION_COLUMN_DESCR = "descr";
	
	const PROMOTION_SERVICE_TABLE = "promotionservice";
	const PROMOTION_SERVICE_COLUMN_ID = "id";
	const PROMOTION_SERVICE_COLUMN_SID = "sid";
	const PROMOTION_SERVICE_COLUMN_PID = "pid";
	
	const USER_SERVICE_TABLE = "userservice";
	const USER_SERVICE_COLUMN_ID = "id";
	const USER_SERVICE_COLUMN_SID = "sid";
	const USER_SERVICE_COLUMN_UID = "uid";
	const USER_SERVICE_COLUMN_DATE_FROM = "date_from";
	const USER_SERVICE_COLUMN_DATE_TO = "date_to";
	const USER_SERVICE_COLUMN_PRICE = "price";
	const USER_SERVICE_COLUMN_WARN = "warn";
	
	const PAYMENT_TABLE = "payment";
	const PAYMENT_COLUMN_ID = "id";
	const PAYMENT_COLUMN_USID = "usid";
	const PAYMENT_COLUMN_PART = "part";
	const PAYMENT_COLUMN_IS_PAID = "is_paid";
	const PAYMENT_COLUMN_PAID_TILL_DATE = "till_day";
	
	const TICKET_TABLE = "ticket";
	const TICKET_COLUMN_ID = "id";
	const TICKET_COLUMN_USID = "usid";
	const TICKET_COLUMN_UID = "uid";
	const TICKET_COLUMN_ACTIVE = "active";
	
	const TICKET_DESCRIPTION_TABLE = "ticketDescription";
	const TICKET_DESCRIPTION_COLUMN_ID = "id";
	const TICKET_DESCRIPTION_COLUMN_TICKET_ID = "tid";
	const TICKET_DESCRIPTION_COLUMN_DESC = "descr";
	const TICKET_DESCRIPTION_COLUMN_USER_ID = "uid";

}

?>